/**
 * 
 */
package com.sqq.model.kl;

import java.util.List;

import com.jfinal.ext.plugin.tablebind.TableBind;
import com.jfinal.plugin.activerecord.Db;
import com.jfinal.plugin.activerecord.Record;
import com.sqq.jfinalbase.SqqModel;

/**
 *@author gqy
 *2015-1-13
 */

@TableBind(tableName = "router_macscan")
public class RouterMacScanModel extends SqqModel<RouterMacScanModel> {

	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;
	public static RouterMacScanModel dao = new RouterMacScanModel();
	
	/**
	 * 
	 * @param timeTag  开始统计的
	 * @return
	 */
	public static List<Record> list(String timeTag) {
		String sql = "select * from router_macscan where mac is not null and create_time> '"+timeTag+"' order by gw_mac,mac,create_time ";
        List<Record> find = Db.find(sql);
        return find;
    }
}
